package com.ixuestar.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.ixuestar.entity.ExaminationInfo;
import com.ixuestar.entity.ExaminationQuestions;
import com.ixuestar.entity.ExaminationResults;
import com.ixuestar.entity.Examinationsubject;
import com.ixuestar.entity.MemberAndParents;
import com.ixuestar.entity.MemberStudent;
import com.ixuestar.entity.MembershipInfo;
import com.ixuestar.entity.MembershipVipInfo;
import com.ixuestar.entity.Membershiparents;
import com.ixuestar.entity.QuestionScore;
import com.ixuestar.entity.School;
import com.ixuestar.entity.SchoolClass;
import com.ixuestar.entity.SchoolGrade;
import com.ixuestar.entity.SchoolStudent;
import com.ixuestar.entity.Subject;
import com.ixuestar.entity.Temp;

public interface IxuestarParentsMapper {

	//查询会员信息
	public MembershipInfo getMembershipInfo(@Param("map")Map<String, Object>map);
	//写入绑定家长信息
	public void writeMembershiparentsInfo(Membershiparents membershiparents);
	//写入绑定关系
	public void writeMemberAndParentsInfo(MemberAndParents memberAndParents);
	//获取学校列表
	public List<School> getSchoolInfo(@Param("map")Map<String, Object>map);
	//获取学校的年级列表
	public List<SchoolGrade> getSchoolGrades(@Param("map")Map<String, Object>map);
	//获取年级的班级列表
	public List<SchoolClass> getSchoolClasses(@Param("map")Map<String, Object>map);
	//获取班级的学生列表
	public List<SchoolStudent> getSchoolStudents(@Param("map")Map<String, Object>map);
	//获取家长用户基本信息
	public Membershiparents getMembershiparents(@Param("map")Map<String, Object>map);
	//获取家长的关系信息
	public List<MemberAndParents> getMemberAndParents(@Param("map")Map<String, Object>map);
	//获取学生信息与会员卡关系
	public MemberStudent getMemberStudent(@Param("map")Map<String, Object>map);
	//获取临沂一中高三的考试列表
	public List<ExaminationInfo> getExaminationList(@Param("map")Map<String, Object>map);
	//获取科目id
	public Subject getSubjectInfo(@Param("map")Map<String, Object>map);
	//获取考试科目的信息id
	public List<Examinationsubject> getExaminationsubject(@Param("map")Map<String,Object>map);
	//获取考试成绩
	public List<ExaminationResults> getExaminationResults(@Param("map")Map<String,Object>map);
	//获取考试的班级平均分和年级平均分
	public Temp getGradeAverage(@Param("ixesId")String ixesId);
	public Temp getClassAverage(@Param("map")Map<String,Object>map);
	//获取科目的题目列表
	public List<ExaminationQuestions> getExaminationQuestions(@Param("map")Map<String,Object>map);
	//获取题目的详细得分情况
	public QuestionScore getQuestionScores(@Param("map")Map<String,Object>map);
	//获取题目的平均得分
	public Temp getQuestionAvgScores(@Param("map")Map<String,Object>map);
	//创建vip账户
	public void writeMembershipVipInfo(MembershipVipInfo membershipVipInfo); 
	//获取学生会员信息
	public MembershipVipInfo getMembershipVipInfo(@Param("map")Map<String,Object>map);
	//修改用户的openId
	public void updateIxmpOpenId(Membershiparents membershiparents);
}
